{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2025-08-18T17:11:35.480123400Z",
     "start_time": "2025-08-18T17:11:35.011299200Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "amount = pd.read_csv('Amount.csv')\n",
    "close = pd.read_csv('Close.csv')\n",
    "index = pd.read_csv('Index.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "outputs": [
    {
     "data": {
      "text/plain": "    Unnamed: 0  000004.SZ  000005.SZ  000006.SZ  000007.SZ  000008.SZ  \\\n0    2020-5-11   71758654    8646166   39260350   11581592   60731821   \n1    2020-5-12  189800103    8148458   31600828   56362125   47844458   \n2    2020-5-13  225926270    7984027   52078204   57015848   45065805   \n3    2020-5-14  246040612   13163443   59942356   43721571   43929976   \n4    2020-5-15  225658340    9583328   84371498   49904802   53694385   \n..         ...        ...        ...        ...        ...        ...   \n295  2021-7-23  271400900   62169442   37134134   30741997   21112891   \n296  2021-7-26  261179178   55127611   42695291   28695405   47821420   \n297  2021-7-27  256662454   37126745   26709922   34494068   28500663   \n298  2021-7-28  198581993   32925617   34719143   21304411   31179922   \n299  2021-7-29  176325258   21895379   22903196   22578328   18272562   \n\n      000009.SZ  000010.SZ  000011.SZ   000012.SZ  ...  603985.SH  603987.SH  \\\n0     676739525    8884724   58123798   136747997  ...   31235994  207415450   \n1     515146763   17422457   26931335    65564506  ...   40140797  200310976   \n2     516740767    8136005   18211601    54847369  ...   87112448  270695855   \n3     487200518   14942207   23616097    58522486  ...   31498109  136510962   \n4     602491895    6138706   50499238    54489922  ...   39229100  183660284   \n..          ...        ...        ...         ...  ...        ...        ...   \n295  2645971910   48686539  134686058   974108694  ...   57641068  232030210   \n296  1518652235   28657092   88911741   701239353  ...   99972930  166097771   \n297  2091246064   18020494   62757162  1073130196  ...  126324325  160260749   \n298  3166857852   23952621   51710963   846489284  ...   83815943  223684128   \n299  2061878984   14477392   48796809   803520342  ...   55648957  233143560   \n\n     603988.SH  603989.SH  603990.SH  603991.SH  603996.SH  603997.SH  \\\n0    315288716   96436939   45730518   61366932    6939264   97913792   \n1    170019435   73733919   66906439   53097160   10491545   61557107   \n2    218803665   53549592   62067956   31836019   12673316   97668389   \n3    316585972   32066950   78891375   48411623    5408658  119399244   \n4    200196578   55367321   97566781   38696516    5323522  118002670   \n..         ...        ...        ...        ...        ...        ...   \n295  149989809  267187604  201415079   15943701    5867762   55510413   \n296  137325526  230003665  205395606   13124971    8710344   69763592   \n297  123573143  218419953  170289060   16093601   18244133   70639310   \n298   90859805  152366086  172047123   16035661   11190017   74299684   \n299   57975192  173199298  262297948   21147324   22196344   68543784   \n\n     603998.SH  603999.SH  \n0     10922688   22071987  \n1     15752209   18165041  \n2     16489354   18430070  \n3     19422639   23956972  \n4     10592959   22848459  \n..         ...        ...  \n295   11645263   10316491  \n296   17068769   11833887  \n297   13075213    8914977  \n298   14890681   12515864  \n299    9509540    6240659  \n\n[300 rows x 3248 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unnamed: 0</th>\n      <th>000004.SZ</th>\n      <th>000005.SZ</th>\n      <th>000006.SZ</th>\n      <th>000007.SZ</th>\n      <th>000008.SZ</th>\n      <th>000009.SZ</th>\n      <th>000010.SZ</th>\n      <th>000011.SZ</th>\n      <th>000012.SZ</th>\n      <th>...</th>\n      <th>603985.SH</th>\n      <th>603987.SH</th>\n      <th>603988.SH</th>\n      <th>603989.SH</th>\n      <th>603990.SH</th>\n      <th>603991.SH</th>\n      <th>603996.SH</th>\n      <th>603997.SH</th>\n      <th>603998.SH</th>\n      <th>603999.SH</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>2020-5-11</td>\n      <td>71758654</td>\n      <td>8646166</td>\n      <td>39260350</td>\n      <td>11581592</td>\n      <td>60731821</td>\n      <td>676739525</td>\n      <td>8884724</td>\n      <td>58123798</td>\n      <td>136747997</td>\n      <td>...</td>\n      <td>31235994</td>\n      <td>207415450</td>\n      <td>315288716</td>\n      <td>96436939</td>\n      <td>45730518</td>\n      <td>61366932</td>\n      <td>6939264</td>\n      <td>97913792</td>\n      <td>10922688</td>\n      <td>22071987</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2020-5-12</td>\n      <td>189800103</td>\n      <td>8148458</td>\n      <td>31600828</td>\n      <td>56362125</td>\n      <td>47844458</td>\n      <td>515146763</td>\n      <td>17422457</td>\n      <td>26931335</td>\n      <td>65564506</td>\n      <td>...</td>\n      <td>40140797</td>\n      <td>200310976</td>\n      <td>170019435</td>\n      <td>73733919</td>\n      <td>66906439</td>\n      <td>53097160</td>\n      <td>10491545</td>\n      <td>61557107</td>\n      <td>15752209</td>\n      <td>18165041</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2020-5-13</td>\n      <td>225926270</td>\n      <td>7984027</td>\n      <td>52078204</td>\n      <td>57015848</td>\n      <td>45065805</td>\n      <td>516740767</td>\n      <td>8136005</td>\n      <td>18211601</td>\n      <td>54847369</td>\n      <td>...</td>\n      <td>87112448</td>\n      <td>270695855</td>\n      <td>218803665</td>\n      <td>53549592</td>\n      <td>62067956</td>\n      <td>31836019</td>\n      <td>12673316</td>\n      <td>97668389</td>\n      <td>16489354</td>\n      <td>18430070</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>2020-5-14</td>\n      <td>246040612</td>\n      <td>13163443</td>\n      <td>59942356</td>\n      <td>43721571</td>\n      <td>43929976</td>\n      <td>487200518</td>\n      <td>14942207</td>\n      <td>23616097</td>\n      <td>58522486</td>\n      <td>...</td>\n      <td>31498109</td>\n      <td>136510962</td>\n      <td>316585972</td>\n      <td>32066950</td>\n      <td>78891375</td>\n      <td>48411623</td>\n      <td>5408658</td>\n      <td>119399244</td>\n      <td>19422639</td>\n      <td>23956972</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>2020-5-15</td>\n      <td>225658340</td>\n      <td>9583328</td>\n      <td>84371498</td>\n      <td>49904802</td>\n      <td>53694385</td>\n      <td>602491895</td>\n      <td>6138706</td>\n      <td>50499238</td>\n      <td>54489922</td>\n      <td>...</td>\n      <td>39229100</td>\n      <td>183660284</td>\n      <td>200196578</td>\n      <td>55367321</td>\n      <td>97566781</td>\n      <td>38696516</td>\n      <td>5323522</td>\n      <td>118002670</td>\n      <td>10592959</td>\n      <td>22848459</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>295</th>\n      <td>2021-7-23</td>\n      <td>271400900</td>\n      <td>62169442</td>\n      <td>37134134</td>\n      <td>30741997</td>\n      <td>21112891</td>\n      <td>2645971910</td>\n      <td>48686539</td>\n      <td>134686058</td>\n      <td>974108694</td>\n      <td>...</td>\n      <td>57641068</td>\n      <td>232030210</td>\n      <td>149989809</td>\n      <td>267187604</td>\n      <td>201415079</td>\n      <td>15943701</td>\n      <td>5867762</td>\n      <td>55510413</td>\n      <td>11645263</td>\n      <td>10316491</td>\n    </tr>\n    <tr>\n      <th>296</th>\n      <td>2021-7-26</td>\n      <td>261179178</td>\n      <td>55127611</td>\n      <td>42695291</td>\n      <td>28695405</td>\n      <td>47821420</td>\n      <td>1518652235</td>\n      <td>28657092</td>\n      <td>88911741</td>\n      <td>701239353</td>\n      <td>...</td>\n      <td>99972930</td>\n      <td>166097771</td>\n      <td>137325526</td>\n      <td>230003665</td>\n      <td>205395606</td>\n      <td>13124971</td>\n      <td>8710344</td>\n      <td>69763592</td>\n      <td>17068769</td>\n      <td>11833887</td>\n    </tr>\n    <tr>\n      <th>297</th>\n      <td>2021-7-27</td>\n      <td>256662454</td>\n      <td>37126745</td>\n      <td>26709922</td>\n      <td>34494068</td>\n      <td>28500663</td>\n      <td>2091246064</td>\n      <td>18020494</td>\n      <td>62757162</td>\n      <td>1073130196</td>\n      <td>...</td>\n      <td>126324325</td>\n      <td>160260749</td>\n      <td>123573143</td>\n      <td>218419953</td>\n      <td>170289060</td>\n      <td>16093601</td>\n      <td>18244133</td>\n      <td>70639310</td>\n      <td>13075213</td>\n      <td>8914977</td>\n    </tr>\n    <tr>\n      <th>298</th>\n      <td>2021-7-28</td>\n      <td>198581993</td>\n      <td>32925617</td>\n      <td>34719143</td>\n      <td>21304411</td>\n      <td>31179922</td>\n      <td>3166857852</td>\n      <td>23952621</td>\n      <td>51710963</td>\n      <td>846489284</td>\n      <td>...</td>\n      <td>83815943</td>\n      <td>223684128</td>\n      <td>90859805</td>\n      <td>152366086</td>\n      <td>172047123</td>\n      <td>16035661</td>\n      <td>11190017</td>\n      <td>74299684</td>\n      <td>14890681</td>\n      <td>12515864</td>\n    </tr>\n    <tr>\n      <th>299</th>\n      <td>2021-7-29</td>\n      <td>176325258</td>\n      <td>21895379</td>\n      <td>22903196</td>\n      <td>22578328</td>\n      <td>18272562</td>\n      <td>2061878984</td>\n      <td>14477392</td>\n      <td>48796809</td>\n      <td>803520342</td>\n      <td>...</td>\n      <td>55648957</td>\n      <td>233143560</td>\n      <td>57975192</td>\n      <td>173199298</td>\n      <td>262297948</td>\n      <td>21147324</td>\n      <td>22196344</td>\n      <td>68543784</td>\n      <td>9509540</td>\n      <td>6240659</td>\n    </tr>\n  </tbody>\n</table>\n<p>300 rows × 3248 columns</p>\n</div>"
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amount"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2025-08-18T17:11:39.054986100Z",
     "start_time": "2025-08-18T17:11:39.034338700Z"
    }
   },
   "id": "8fb0314754f8b9fb"
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "outputs": [
    {
     "data": {
      "text/plain": "(300, 3248)"
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amount.shape"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2025-08-18T17:12:06.793841500Z",
     "start_time": "2025-08-18T17:12:06.788308100Z"
    }
   },
   "id": "f8791b8f1c4be5ac"
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false
   },
   "id": "637e4ce3c7bdd3f3"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
